package god530.com.simpleapp_slide.account.title.db;

/**
 * 关于数据库的所有静态常量， 实验性质
 * Created by WhatINeed on 16-1-30.
 */
public class DBConstants {

    public static final String DB_NAME = "god530";
    public static final int vesion = 1;


//    CREATE TABLE account_type (id INTEGER PRIMARY KEY AUTOINCREMENT,key, value, MONEY);
//    CREATE TABLE borrow (id INTEGER PRIMARY KEY AUTOINCREMENT, uri, MONEY, type_detail, account_detail,  member, date, remind_model, remind_date, interest, remarks, time_span,update_time);
//    CREATE TABLE borrow_member (id INTEGER PRIMARY KEY AUTOINCREMENT,name, MONEY);
//    CREATE TABLE budget (id INTEGER PRIMARY KEY AUTOINCREMENT,type, total, expenses);
//    CREATE TABLE delete_item (id INTEGER PRIMARY KEY AUTOINCREMENT,time_span);
//    CREATE TABLE expenses (id INTEGER PRIMARY KEY AUTOINCREMENT, uri, MONEY, type_main, type_detail, account_detail, date, member, remarks, time_span,update_time);
//    CREATE TABLE expenses_left (id INTEGER PRIMARY KEY AUTOINCREMENT,left);
//    CREATE TABLE expenses_right (id INTEGER PRIMARY KEY AUTOINCREMENT,key, value, usually_key);
//    CREATE TABLE income_type (id INTEGER PRIMARY KEY AUTOINCREMENT,income_type);
//    CREATE TABLE income (id INTEGER PRIMARY KEY AUTOINCREMENT, uri, MONEY, type_detail,account_detail, date, member,remarks, time_span,update_time);
//    CREATE TABLE member (id INTEGER PRIMARY KEY AUTOINCREMENT,member);
//    CREATE TABLE remind (id INTEGER PRIMARY KEY AUTOINCREMENT,isBorrow, person, MONEY, time_remind, timeSpanOfSequence);
//    CREATE TABLE time_sequence (id INTEGER PRIMARY KEY AUTOINCREMENT,time_span_four, account_type, date, time_span);
//    CREATE TABLE transfer (id INTEGER PRIMARY KEY AUTOINCREMENT, uri, MONEY, type_detail,transfer_account_from, transfer_account_to, date, member, remarks,time_span,update_time);


    // drop table account_type
    // drop table borrow

    // account_type
    public static final String TABLE_ACCOUNTTYPE = "account_type";
    public static final String CREATE_ACCOUNTTYPE_SQL = "CREATE TABLE account_type (id INTEGER PRIMARY KEY AUTOINCREMENT,key, value, MONEY);";
    public static final String DROP_ACCOUNTTYPE = "drop table account_type";
    public static final String ACCOUNTTYPE_ID = "id";
    public static final String ACCOUNTTYPE_KEY = "key";
    public static final String ACCOUNTTYPE_VALUE = "value";
    public static final String ACCOUNTTYPE_MONEY = "MONEY";

    //borrow
    public static final String TABLE_BORROW = "borrow";
    public static final String CREATE_BORROW_SQL = "CREATE TABLE borrow (id INTEGER PRIMARY KEY AUTOINCREMENT, uri, MONEY, type_detail, account_detail,  member, date, remind_model, remind_date, interest, remarks, time_span,update_time);";
    public static final String DROP_BORROW = "drop table borrow";
    public static final String BORROW_ID = "id";
    public static final String BORROW_URI = "uri";
    public static final String BORROW_MONEY = "MONEY";
    public static final String BORROW_TYPEDETAIL = "type_detail";
    public static final String BORROW_ACCOUNTDETAIL = "account_detail";
    public static final String BORROW_MEMBER = "member";
    public static final String BOOROW_DATE = "date";
    public static final String BORROW_REMINDDATE = "remind_date";
    public static final String BORROW_INTEREST = "interest";
    public static final String BORROW_REMARKS = "remarks";
    public static final String BORROW_TIMESPAN = "time_span";
    public static final String BORROW_UPDATE = "update";

    // borrow_member
    public static final String TABLE_BORROWNUMBER = "borrow_member";
    public static final String CREATE_BORROWNUMBER_SQL = "CREATE TABLE borrow_member (id INTEGER PRIMARY KEY AUTOINCREMENT,name, MONEY);";
    public static final String DROP_BORROW_MEMBER = "drop table borrow_member";
    public static final String BORROWNUMBER_ID = "id";
    public static final String BORROWNUMBER_NAME = "name";
    public static final String BORROWNUMBER_MONEY = "MONEY";

    //budget
    public static final String TABLE_BUDGET = "budget";
    public static final String CREATE_BUDGET_SQL = "CREATE TABLE budget (id INTEGER PRIMARY KEY AUTOINCREMENT,type, total, expenses);";
    public static final String DROP_BUDGET = "drop table budget";
    public static final String BUDGET_ID = "id";
    public static final String BUDGET_TYPE = "type";
    public static final String BUDGET_TOTAL = "total";
    public static final String BUDGET_EXPENSES = "expenses";

    //delete_item
    public static final String TABLE_DELETEITEM = "delete_item";
    public static final String CREATE_DELETEITEM_SQL = "CREATE TABLE delete_item (id INTEGER PRIMARY KEY AUTOINCREMENT,time_span);";
    public static final String DROP_DELETE_ITEM = "drop table delete_item";
    public static final String DELETEITEM_ID = "id";
    public static final String DELETEITEM_TIMESPAN = "time_span";

    // expenses
    public static final String TABLE_EXPENSES = "expenses";
    public static final String CREATE_EXPENSES_SQL = "CREATE TABLE expenses (id INTEGER PRIMARY KEY AUTOINCREMENT, uri, MONEY, type_main, type_detail, account_detail, date, member, remarks, time_span,update_time);";
    public static final String DROP_EXPENSES = "drop table expenses";
    public static final String EXPENSES_ID = "id";
    public static final String EXPENSES_URI = "uri";
    public static final String EXPENSES_MONEY = "MONEY";
    public static final String EXPENSES_TYEPMAIN = "type_main";
    public static final String EXPENSES_TYPEDETAIL = "type_detail";
    public static final String EXPENSES_ACCOUNTDETAIL = "account_detail";
    public static final String EXPENSES_DATE = "date";
    public static final String EXPENSES_MEMBER = "member";
    public static final String EXPENSES_REMARKS = "remarks";
    public static final String EXPENSES_TIMESPAN = "time_span";
    public static final String EXPENSES_UPDATETIME = "update_time";

    // expenses_left
    public static final String TABLE_EXPENSESLEFT = "expenses_left";
    public static final String CREATE_EXPENSELEFT_SQL = "CREATE TABLE expenses_left (id INTEGER PRIMARY KEY AUTOINCREMENT,left);";
    public static final String DROP_EXPENSES_LEFT = "drop table expenses_left";
    public static final String EXPENSESLEFT_ID = "id";
    public static final String EXPENSESLEFT_LEFT = "left";

    // expenses_right
    public static final String TABLE_EXPENSESRIGHT = "expenses_right";
    public static final String CREATE_EXPENSESRIGHT_SQL = "CREATE TABLE expenses_right (id INTEGER PRIMARY KEY AUTOINCREMENT,key, value, usually_key);";
    public static final String DROP_EXPENSES_RIGHT = "drop table expenses_right";
    public static final String EXPENSESRIGHT_ID = "id";
    public static final String EXPENSESRIGHT_KEY = "key";
    public static final String EXPENSESRIGHT_VALUE = "value";
    public static final String ExpenSESRIGHT_USUALLYKEY = "usually_key";

    // income_type
    public static final String TABLE_INCOMETYPE = "income_type";
    public static final String CREATE_INCOMETYPE_SQL = "CREATE TABLE income_type (id INTEGER PRIMARY KEY AUTOINCREMENT,income_type);";
    public static final String DROP_INCOME_TYPE = "drop table income_type";
    public static final String INCOMETYPE_ID = "id";
    public static final String INCOMETYPE_INCOMETYPE = "income_type";

    // income
    public static final String TABLE_INCOME = "income";
    public static final String CREATE_INCOME_SQL = "CREATE TABLE income (id INTEGER PRIMARY KEY AUTOINCREMENT, uri, MONEY, type_detail,account_detail, date, member,remarks, time_span,update_time);";
    public static final String DROP_INCOME= "drop table income";
    public static final String INCOME_ID = "id";
    public static final String INCOME_URI = "uri";
    public static final String INCOME_MONEY = "MONEY";
    public static final String INCOME_TYPEDETAIL = "type_detail";
    public static final String INCOME_ACCOUNTDETAIL = "account_detail";
    public static final String INCOME_DATE = "date";
    public static final String INCOME_MEMBER = "member";
    public static final String INCOME_REMARKS = "remarks";
    public static final String INCOME_TIMESPAN = "time_span";
    public static final String INCOME_UPDATETIME = "update_time";

    // member
    public static final String TABLE_MEMBER = "member";
    public static final String CREATE_MEMBER_SQL = "CREATE TABLE member (id INTEGER PRIMARY KEY AUTOINCREMENT,member);";
    public static final String DROP_MEMBER = "drop table member";
    public static final String MEMBER_ID = "id";
    public static final String MEMBER_MEMBER = "membert";

    // remind
    public static final String TABLE_REMIND = "remind";
    public static final String CREATE_REMIND_SQL = "CREATE TABLE remind (id INTEGER PRIMARY KEY AUTOINCREMENT,isBorrow, person, MONEY, time_remind, timeSpanOfSequence);";
    public static final String DROP_REMIND = "drop table remind";
    public static final String REMIND_ID = "id";
    public static final String REMIND_ISBORROW = "isBorrow";
    public static final String REMIND_PERSION = "persion";
    public static final String REMIND_MONEY = "MONEY";
    public static final String REMIND_TIMEREMIND = "time_remind";
    public static final String REMIND_TIMESPANSEQUENCE = "timeSpanOfSequnece";

    // time_sequence
    public static final String TABLE_TIMESEQUENCE = "time_sequence";
    public static final String CREATE_TIMESEQUENCE_SQL = "CREATE TABLE time_sequence (id INTEGER PRIMARY KEY AUTOINCREMENT,time_span_four, account_type, date, time_span);";
    public static final String DROP_TIME_SEQUENCE = "drop table time_sequence";
    public static final String TIMESEQUENCE_ID = "id";
    public static final String TIMESEQUENCE_TIMESPANFOUR = "time_span_four";
    public static final String TIMESEQUENCE_ACCOUNTTYPE = "account_type";
    public static final String TIMESEQUENCE_DATE = "date";
    public static final String TIMESEQUENCE_TIMESPAN = "time_span";

    // transfer
    public static final String TABLE_TRANSFER = "transfer";
    public static final String CREATE_TRANSFER_SQL = "CREATE TABLE transfer (id INTEGER PRIMARY KEY AUTOINCREMENT, uri, MONEY, type_detail,transfer_account_from, transfer_account_to, date, member, remarks,time_span,update_time);";
    public static final String DROP_TRANSFER = "drop table transfer";
    public static final String TRANSFER_ID = "id";
    public static final String TRANSFER_URI = "uri";
    public static final String TRANSFER_MONEY = "MONEY";
    public static final String TRANSFER_TYPEDETAIL = "type_detail";
    public static final String TRANSFER_TRANSFERACCOUNTFROM = "transfer_account_from";
    public static final String TRANSFER_TRANSFERACCOUNTTO = "transfer_account_to";
    public static final String TRANSFER_DATE = "date";
    public static final String TRANSFER_MEMBER = "member";
    public static final String TRANSFER_REMARKS = "remarks";
    public static final String TRANSFER_TIMESPAN = "time_span";
    public static final String TRANSFER_UPDATETIME = "update_time";
}
